Hello,

I have a PHP script that interfaces a MySQL database and returns data to a Flash movie. Everything is working as intended except one thing. I have a text field that stores a character A-D, the character is passed through to the Flash movie but my code in the movie to identify the character is not working.

The field displays an "A" but when I try to do anything with the "A", it fails. I have tried using the trim function but my if statement still fails every time. This also fails in the PHP script when I test it there.

I have tried changing the field type and corresponding character to integer and others without luck as well.

Does MySql append any data that is unseen to me? What could the problem be?I'm a noob with all three technologies, so please be gentle in your explanation.

Thanks for your help.

PHP code

// Send data to the Flash movie
echo "&number_s= $number";
echo "&reference_s= $reference";
echo "&question_s= $question";
echo "&response_1_s= $response_1";
echo "&response_2_s= $response_2";
echo "&response_3_s= $response_3";
echo "&response_4_s= $response_4";
echo "&answer_s= $answer";

Flash Code

loadVariables("exam.php",'POST');